package com.system.data.dao;

import com.system.data.model.JingdongComment830;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface JingdongCommentDao {
    @Select("SELECT DISTINCT orderChoose FROM `jingdong_comment_830` where commentSenti='好评' LIMIT 6;")
    List<String> findJingDongOrderChoose();

    @Select("SELECT * FROM `jingdong_comment_830` WHERE orderChoose=#{orderChoose} and commentSenti='好评' LIMIT 3;")
    List<JingdongComment830> findJingDongComment(@Param("orderChoose") String orderChoose);
}